Release 10.1A: OpenEdge Data Management:
DataServer for Microsoft SQL Server

Before you begin

Consider your business needs and deployment strategy when you decide where to build your schema holder. The schema holder can reside on the client machine or on any host in an enterprise configuration. Client schema holders improve performance for some applications. Host schema holders give you the flexibility of having them run as Windows services. Additionally, host schema holders might be easier to maintain. In a WebSpeed configuration, placing the schema holder on the Transaction Server machine optimizes performance.

General schema holder creation tasks

In general, you must do the following to create a schema holder:

Establish the appropriate permissions for pulling the schema image into the schema holder.
Perform some preparatory steps.
Create and then connect an empty OpenEdge database. This database becomes your schema holder and contains your schema image.
Create the schema holder, which involves specifying connection parameters and pulling the schema from the data source.

The following sections describe these steps in detail.